DomainObjects Class Library

ScalarQuery<SelectFromClass> Members

ScalarQuery<SelectFromClass> overview

Public Instance Constructors

ScalarQuery<SelectFromClass> Constructor Initializes a new instance of the Field class.

Public Instance Properties

CommandTimeout (inherited from ScalarQuery) Gets or sets the wait time before terminating the attempt to execute a SQL statement and generating an error.
Distinct (inherited from ScalarQuery) Gets or sets a value indicating whether only unique rows can appear in the result set. Null values are considered equal for the purposes of the DISTINCT keyword.
ExplicitSelectFields (inherited from ScalarQuery) Gets the select fields.
FieldDescriptor (inherited from Field) Gets or sets the field descriptor.
Having (inherited from ScalarQuery) The criteria that will be converted to the HAVING clause of the SQL select statement.
IsTopSpecified (inherited from ScalarQuery) Gets a value indicating whether top is specified.
SelectDistinct (inherited from ScalarQuery) Determine if duplicate rows will be removed when this object is queried from the database.
TargetClass (inherited from ScalarQuery) Gets the class being targeted by this query.
TargetTableMappedObject (inherited from ScalarQuery) Gets the target table mapped object.
Top (inherited from ScalarQuery) Gets or sets the number of rows that will be returned from the query result set.
UnionedQueries (inherited from ScalarQuery) 
Value (inherited from Field) Get an object that represents the run time value. Useful for building Criteria.
Where (inherited from ScalarQuery) Gets or sets the criteria that will be converted to the WHERE clause of the SQL select statement. The getter will always return a non-null value.

Public Instance Methods

Accept (inherited from ScalarQuery) Accepts a visitation.
AddDate (inherited from Field)Overloaded. Returns a new DateTime based upon adding the specified interval to this date.
AddUnion Unions the given query with this query using the 'UNION' SQL clause.
AddUnionAll Unions the given query with this query using the 'UNION ALL' SQL clause.
AppendSql (inherited from ScalarQuery) Appends the SQL.
As (inherited from Field)Overloaded. Sets the alias to be used as the expression name.
Average (inherited from Field)Overloaded. Returns the average of all values in a group including duplicate values. Translates to a AVG(field) SQL function.
BuildObjectGraphQuery (inherited from ScalarQuery) Builds the object graph query.
Count (inherited from Field)Overloaded. Returns the total number of rows from a table, including duplicates, where this field evaluates to a non-null value. Translates to a COUNT(field) SQL function.
DatePart (inherited from Field) Returns a string representing a datepart of a date.
Equals (inherited from Object)Determines whether the specified Object is equal to the current Object.
GetClassesToRetrieve (inherited from ScalarQuery) Builds the classes to retrieve.
GetFullTableName (inherited from ScalarQuery) Get the fully qualified name of the table to which this object maps.
GetHashCode (inherited from Object)Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table.
GetImmediateChildExpressions (inherited from ScalarQuery) Gets the child object model expressions that are directly contained by this expression.
GetInsertableFields (inherited from ScalarQuery) Get the set of insertable Fields to which this object, and any of its sub-types, maps. This is the set of ColumnFields that are populated by the middle tier when a row is inserted into the database.
GetKey (inherited from Field) Get a string representation of the hashcode that uniquely identifies this field instance. This field becomes cached in one of two caches when GetKey is called: 1. If the current thread is executing within an HTTP context, i.e., a web application, then the field is stored in the current HttpSessionState. 2. If the current thread is not executing within an HTTP context, then the field is stored in DomainObject's AppDomain cache. This field can then be retrieved later via a call to GetField. You might want to use the field key as the value of a drop down list in a web page and then retrieve the actual field from the cache when the page is posted back to the server. See a usage example at FieldCaching().
GetNaturalIdentifier (inherited from ScalarQuery) Get a string that identifies this field to a person familiar with the object model. Used when an instance of this field is part of a logging or assertion statement.
GetParentTableMappedObject (inherited from Field) The object that contains this field. For example, the class that contains this member field.
GetRootTableMappedObject (inherited from ScalarQuery) Returns the root table mapped object in this query path; i.e., the starting point of this join path.
GetSelectableFields (inherited from ScalarQuery) Get the set of selectable Fields to which this object, and any of its sub-types, maps.
GetType (inherited from Object)Gets the Type of the current instance.
GetUpdatableFields (inherited from ScalarQuery) Get the set of updatable ColumnFields to which this object, and any of its sub-types, maps. This list would exclude, for example, any primary key columns.
HasAnyComputedPrimaryKeyColumns (inherited from ScalarQuery) Determines whether this table mapped object has any computed primary key columns.
IsCount (inherited from ScalarQuery) Determines whether this instance represents a SQL COUNT statement.
Lower (inherited from Field) Returns the lower case string of this field's values. Translates to a LOWER(field) SQL function.
Max (inherited from Field) Returns the maximum value of the field. Null values are ignored. Translates to a MAX(field) SQL function.
Min (inherited from Field) Returns the minimum value of the field. Null values are ignored. Translates to a MIN(field) SQL function.
Replace (inherited from Field) Replaces all occurrences of substringToFind in the string value of this field with replacementString. Translates to a REPLACE(fieldToSearch, substringToFind, replacementString) SQL function.
ReplaceNull (inherited from Field) Replaces a NULL value for this field with the specified replacement value.
Sum (inherited from Field)Overloaded. Returns the sum of this field's values. Null values are ignored. Translates to a SUM(field) SQL function.
ToString (inherited from Object)Returns a String that represents the current Object.
Upper (inherited from Field) Returns the upper case string of this field's values. Translates to a UPPER(field) SQL function.

See Also

ScalarQuery<SelectFromClass> Class | DomainObjects.Facade.Command Namespace